CREATE PROCEDURE [dbo].[BAEEventSetupGetAvailFunctions] @eventCode varchar(15)
AS
SELECT p.[PRODUCT_CODE], p.[PRODUCT_MAJOR], p.[PRODUCT_MINOR], p.[PROD_TYPE], p.[CATEGORY], p.[TITLE_KEY], p.[TITLE],
       p.[DESCRIPTION], p.[STATUS], p.[NOTE], p.[GROUP_1], p.[GROUP_2], p.[GROUP_3], p.[PRICE_RULES_EXIST], p.[LOT_SERIAL_EXIST],
       p.[PAYMENT_PRIORITY], p.[RENEW_MONTHS], p.[PRORATE], p.[STOCK_ITEM], p.[UNIT_OF_MEASURE], p.[WEIGHT], p.[TAXABLE],
       p.[COMMISIONABLE], p.[COMMISION_PERCENT], p.[DECIMAL_POINTS], p.[INCOME_ACCOUNT], p.[DEFERRED_INCOME_ACCOUNT],
       p.[INVENTORY_ACCOUNT], p.[ADJUSTMENT_ACCOUNT], p.[COG_ACCOUNT], p.[INTENT_TO_EDIT], p.[PRICE_1], p.[PRICE_2], p.[PRICE_3],
       p.[COMPLIMENTARY], p.[ATTRIBUTES], p.[PST_TAXABLE], p.[TAXABLE_VALUE], p.[ORG_CODE], p.[TAX_AUTHORITY], p.[WEB_OPTION],
       p.[IMAGE_URL], p.[APPLY_IMAGE], p.[IS_KIT], p.[INFO_URL], p.[APPLY_INFO], p.[PLP_CODE], p.[PROMOTE], p.[THUMBNAIL_URL],
       p.[APPLY_THUMBNAIL], p.[CATALOG_DESC], p.[WEB_DESC], p.[OTHER_DESC], p.[LOCATION], p.[PREMIUM], p.[FAIR_MARKET_VALUE],
       p.[IS_FR_ITEM], p.[APPEAL_CODE], p.[CAMPAIGN_CODE], p.[TIME_STAMP], p.[ProductKey],
       pf.[PRODUCT_CODE], pf.[FUNCTION_TYPE], pf.[BEGIN_DATE_TIME], pf.[END_DATE_TIME], pf.[SEQ],
       pf.[MINIMUM_ATTENDANCE], pf.[EXPECTED_ATTENDANCE], pf.[GUARANTEED_ATTENDANCE], pf.[ACTUAL_ATTENDANCE], pf.[SETTINGS],
       pf.[SETUP_DATE_TIME], pf.[POST_DATE_TIME], pf.[AUTO_ENROLL], pf.[PRINT_TICKET], pf.[LAST_TICKET], pf.[CEU_TYPE],
       pf.[CEU_AMOUNT], pf.[COURSE_CODE], pf.[OTHER_TICKETS], pf.[CEU_ENTERED], pf.[MAXIMUM_ATTENDANCE], pf.[PARENT],
       pf.[CONFLICT_CODE], pf.[WEB_ENABLED], pf.[WEB_MULTI_REG], pf.[SQUARE_FEET], pf.[IS_FR_ITEM], pf.[IS_GUEST_FUNCTION],
       pf.[CREATE_DETAIL_ACTIVITY], pf.[TIME_STAMP]
  FROM [dbo].[Product] p
       INNER JOIN [dbo].[Product_Function] pf ON p.PRODUCT_CODE COLLATE database_default = pf.PRODUCT_CODE COLLATE database_default
--    WHERE p.PRODUCT_CODE LIKE @eventCode + '%' AND LEN(p.PRODUCT_MINOR) > 1
-- DT:19473 Use PRODUCT_MAJOR for this
WHERE p.PRODUCT_MAJOR = @eventCode AND LEN(p.PRODUCT_MINOR) > 1
-- END DT:19473
      AND (pf.IS_GUEST_FUNCTION IS NULL OR pf.IS_GUEST_FUNCTION = 0)
      AND p.PRODUCT_MINOR COLLATE database_default NOT IN ( SELECT [FunctionCode] COLLATE database_default
                                                              FROM [dbo].[EventSetupFunctionGroup]
                                                             WHERE EventCode = @eventCode )
      AND pf.WEB_ENABLED = '1'
ORDER BY TITLE_KEY

GO